Count (fld), Count (fld, condFld), Count (fld, condFld, cond), Count (x)

Basic and Crystal syntax.

Arguments
Returns

Fractional Number

Action

Enables you to count the values that appear in your report (for a specified field). For example:

Examples

The following examples are applicable to both Basic and Crystal syntax:

Count({orders.AMOUNT}, {orders.CUSTOMER ID})

This formula counts the number of orders in each group of orders in the Amount field (the total orders for each month). The orders are separated into groups whenever the value in the Customer ID field changes.

Count({orders.ORDER AMOUNT}, {orders.ORDER DATE}, "monthly")

Counts the number of orders in each group of orders in the Amount field (the total orders for each month). The orders are separated into groups whenever the value in the Date field changes to a new month.

The following examples are applicable to Crystal syntax:

If Count({orders.ORDER ID}) >= 100 Then

    "Congratulations on meeting your quota!"

Else

    ""

Prints the congratulatory message if the number of orders is 100 or more, and prints nothing if the number of orders is less than 100.

Count([1,2,3,4,5])

Returns 5. Counts the total number of values in the array.

Note:    Using this function in a formula forces the formula to be evaluated at print time.

For more information on evaluation time considerations, see Evaluation Time functions.



Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com